package com.lxyk.dao.student;

import com.lxyk.domain.StudentVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface StudentDao {

    //根据班级id查询学生信息
    @Select("select student.*,classes.className,classes.openTime,classes.closeTime,classes.statusClass,classes.speed,classes.classSize,classes.effeNumber from student,classes where student.cid=classes.id and student.cid=#{cid}")
    List<StudentVO> findStudentByCid(Integer cid);

    //查询所有学生信息
    @Select("select student.*,classes.className,classes.openTime,classes.closeTime,classes.statusClass statusClass,classes.speed,classes.classSize,classes.effeNumber from student,classes where student.cid=classes.id")
    List<StudentVO> findAllStudent();

}
